NYC Airbnb Listings Profile

Dataset statistics

Number of variables	15
Number of observations	43555
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	5.3 MiB
Average record size in memory	128.0 B

Variable types

Numeric	11
Categorical	2
Text	2

Alerts

`id` is highly overall correlated with `host_id`	High correlation
`host_id` is highly overall correlated with `id`	High correlation
`latitude` is highly overall correlated with `nbhd_group`	High correlation
`longitude` is highly overall correlated with `nbhd_group`	High correlation
`min_nights` is highly overall correlated with `reviews_count_ltm`	High correlation
`reviews_count` is highly overall correlated with `monthly_reviews` and 1 other fields	High correlation
`monthly_reviews` is highly overall correlated with `reviews_count` and 1 other fields	High correlation
`reviews_count_ltm` is highly overall correlated with `min_nights` and 2 other fields	High correlation
`nbhd_group` is highly overall correlated with `latitude` and 1 other fields	High correlation
`id` has unique values	Unique
`reviews_count` has 10493 (24.1%) zeros	Zeros
`monthly_reviews` has 10493 (24.1%) zeros	Zeros
`availability_365` has 13999 (32.1%) zeros	Zeros
`reviews_count_ltm` has 21644 (49.7%) zeros	Zeros

Reproduction

Analysis started	2023-08-31 16:17:22.889545
Analysis finished	2023-08-31 16:17:32.560190
Duration	9.67 seconds
Software version	ydata-profiling vv4.3.1
Download configuration	config.json

id
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	43555
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.5827836 × 10¹⁷

Minimum	2595
Maximum	9.0598181 × 10¹⁷
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	680.5 KiB

Quantile statistics

Minimum	2595
5-th percentile	3262907.5
Q1	20220041
median	45617541
Q3	6.798155 × 10¹⁷
95-th percentile	8.6189966 × 10¹⁷
Maximum	9.0598181 × 10¹⁷
Range	9.0598181 × 10¹⁷
Interquartile range (IQR)	6.798155 × 10¹⁷

Descriptive statistics

Standard deviation	3.606055 × 10¹⁷
Coefficient of variation (CV)	1.3961894
Kurtosis	-1.3665879
Mean	2.5827836 × 10¹⁷
Median Absolute Deviation (MAD)	34621075
Skewness	0.73106355
Sum	-3.2000551 × 10¹⁸
Variance	1.3003633 × 10³⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5121	1	< 0.1%
5.599344622 × 10¹⁷	1	< 0.1%
5.615164303 × 10¹⁷	1	< 0.1%
5.643992905 × 10¹⁷	1	< 0.1%
5.615212336 × 10¹⁷	1	< 0.1%
5.644088355 × 10¹⁷	1	< 0.1%
5.61535863 × 10¹⁷	1	< 0.1%
5.644469911 × 10¹⁷	1	< 0.1%
5.598813841 × 10¹⁷	1	< 0.1%
5.615808741 × 10¹⁷	1	< 0.1%
Other values (43545)	43545	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2595	1	< 0.1%
5121	1	< 0.1%
5136	1	< 0.1%
5178	1	< 0.1%
5203	1	< 0.1%
5803	1	< 0.1%
6848	1	< 0.1%
6872	1	< 0.1%
6990	1	< 0.1%
7064	1	< 0.1%

Value	Count	Frequency (%)
9.059818095 × 10¹⁷	1	< 0.1%
9.059749213 × 10¹⁷	1	< 0.1%
9.059714426 × 10¹⁷	1	< 0.1%
9.05955885 × 10¹⁷	1	< 0.1%
9.059263206 × 10¹⁷	1	< 0.1%
9.05856981 × 10¹⁷	1	< 0.1%
9.058210671 × 10¹⁷	1	< 0.1%
9.056946472 × 10¹⁷	1	< 0.1%
9.056570747 × 10¹⁷	1	< 0.1%
9.056075412 × 10¹⁷	1	< 0.1%

host_id
Real number (ℝ)

HIGH CORRELATION

Distinct	27393
Distinct (%)	62.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.5593631 × 10⁸

Minimum	1678
Maximum	5.1802193 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	680.5 KiB

Quantile statistics

Minimum	1678
5-th percentile	1410227.1
Q1	16477260
median	78464432
Q3	2.789252 × 10⁸
95-th percentile	4.8305642 × 10⁸
Maximum	5.1802193 × 10⁸
Range	5.1802026 × 10⁸
Interquartile range (IQR)	2.6244794 × 10⁸

Descriptive statistics

Standard deviation	1.6557727 × 10⁸
Coefficient of variation (CV)	1.0618263
Kurtosis	-0.75610799
Mean	1.5593631 × 10⁸
Median Absolute Deviation (MAD)	74767926
Skewness	0.83525796
Sum	6.791806 × 10¹²
Variance	2.7415834 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
107434423	569	1.3%
3223938	487	1.1%
305240193	412	0.9%
496944100	342	0.8%
19303369	235	0.5%
200239515	219	0.5%
204704622	207	0.5%
162280872	176	0.4%
137358866	142	0.3%
501999278	138	0.3%
Other values (27383)	40628	93.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1678	1	< 0.1%
2234	1	< 0.1%
2438	1	< 0.1%
2571	1	< 0.1%
2782	1	< 0.1%
2787	7	< 0.1%
2845	3	< 0.1%
2868	1	< 0.1%
3757	1	< 0.1%
3869	1	< 0.1%

Value	Count	Frequency (%)
518021933	1	< 0.1%
517950291	1	< 0.1%
517874537	1	< 0.1%
517704969	1	< 0.1%
517701802	1	< 0.1%
517613113	1	< 0.1%
517575835	1	< 0.1%
517575039	1	< 0.1%
517427494	1	< 0.1%
517408696	1	< 0.1%

nbhd_group
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	680.5 KiB

Manhattan	18101
Brooklyn	16341
Queens	6971
Bronx	1710
Staten Island	432

Length

Max length	13
Median length	9
Mean length	8.0272988
Min length	5

Characters and Unicode

Total characters	349629
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Brooklyn
2nd row	Manhattan
3rd row	Manhattan
4th row	Brooklyn
5th row	Manhattan

Common Values

Value	Count	Frequency (%)
Manhattan	18101	41.6%
Brooklyn	16341	37.5%
Queens	6971	16.0%
Bronx	1710	3.9%
Staten Island	432	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
manhattan	18101	41.2%
brooklyn	16341	37.1%
queens	6971	15.8%
bronx	1710	3.9%
staten	432	1.0%
island	432	1.0%

Most occurring characters

Value	Count	Frequency (%)
n	62088	17.8%
a	55167	15.8%
t	37066	10.6%
o	34392	9.8%
M	18101	5.2%
h	18101	5.2%
B	18051	5.2%
r	18051	5.2%
l	16773	4.8%
y	16341	4.7%
Other values (10)	55498	15.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	305210	87.3%
Uppercase Letter	43987	12.6%
Space Separator	432	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	62088	20.3%
a	55167	18.1%
t	37066	12.1%
o	34392	11.3%
h	18101	5.9%
r	18051	5.9%
l	16773	5.5%
y	16341	5.4%
k	16341	5.4%
e	14374	4.7%
Other values (4)	16516	5.4%

Uppercase Letter

Value	Count	Frequency (%)
M	18101	41.2%
B	18051	41.0%
Q	6971	15.8%
S	432	1.0%
I	432	1.0%

Space Separator

Value	Count	Frequency (%)
	432	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	349197	99.9%
Common	432	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	62088	17.8%
a	55167	15.8%
t	37066	10.6%
o	34392	9.8%
M	18101	5.2%
h	18101	5.2%
B	18051	5.2%
r	18051	5.2%
l	16773	4.8%
y	16341	4.7%
Other values (9)	55066	15.8%

Common

Value	Count	Frequency (%)
	432	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	349629	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	62088	17.8%
a	55167	15.8%
t	37066	10.6%
o	34392	9.8%
M	18101	5.2%
h	18101	5.2%
B	18051	5.2%
r	18051	5.2%
l	16773	4.8%
y	16341	4.7%
Other values (10)	55498	15.9%

nbhd
Text

Distinct	223
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	680.5 KiB

Length

Max length	25
Median length	17
Mean length	11.739915
Min length	4

Characters and Unicode

Total characters	511332
Distinct characters	54
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	Bedford-Stuyvesant
2nd row	Midtown
3rd row	Lower East Side
4th row	Sunset Park
5th row	Chinatown

Value	Count	Frequency (%)
east	5589	8.0%
side	3884	5.5%
bedford-stuyvesant	3175	4.5%
upper	3151	4.5%
heights	2983	4.2%
harlem	2935	4.2%
williamsburg	2588	3.7%
west	2151	3.1%
village	2140	3.0%
midtown	2079	3.0%
Other values (236)	39608	56.4%

Most occurring characters

Value	Count	Frequency (%)
e	46205	9.0%
i	35991	7.0%
s	34826	6.8%
t	34741	6.8%
a	33502	6.6%
r	29514	5.8%
l	28221	5.5%
	26728	5.2%
n	23793	4.7%
o	22584	4.4%
Other values (44)	195227	38.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	404719	79.1%
Uppercase Letter	74390	14.5%
Space Separator	26728	5.2%
Dash Punctuation	3633	0.7%
Other Punctuation	1862	0.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	46205	11.4%
i	35991	8.9%
s	34826	8.6%
t	34741	8.6%
a	33502	8.3%
r	29514	7.3%
l	28221	7.0%
n	23793	5.9%
o	22584	5.6%
d	18838	4.7%
Other values (15)	96504	23.8%

Uppercase Letter

Value	Count	Frequency (%)
H	10070	13.5%
S	9944	13.4%
B	7264	9.8%
E	6354	8.5%
W	6274	8.4%
C	4842	6.5%
M	3540	4.8%
F	3271	4.4%
U	3204	4.3%
G	2983	4.0%
Other values (14)	16644	22.4%

Other Punctuation

Value	Count	Frequency (%)
'	1650	88.6%
.	211	11.3%
,	1	0.1%

Space Separator

Value	Count	Frequency (%)
	26728	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3633	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	479109	93.7%
Common	32223	6.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	46205	9.6%
i	35991	7.5%
s	34826	7.3%
t	34741	7.3%
a	33502	7.0%
r	29514	6.2%
l	28221	5.9%
n	23793	5.0%
o	22584	4.7%
d	18838	3.9%
Other values (39)	170894	35.7%

Common

Value	Count	Frequency (%)
	26728	82.9%
-	3633	11.3%
'	1650	5.1%
.	211	0.7%
,	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	511332	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	46205	9.0%
i	35991	7.0%
s	34826	6.8%
t	34741	6.8%
a	33502	6.6%
r	29514	5.8%
l	28221	5.5%
	26728	5.2%
n	23793	4.7%
o	22584	4.4%
Other values (44)	195227	38.2%

latitude
Real number (ℝ)

HIGH CORRELATION

Distinct	24586
Distinct (%)	56.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.72867

Minimum	40.500314
Maximum	40.91138
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	680.5 KiB

Quantile statistics

Minimum	40.500314
5-th percentile	40.640904
Q1	40.68765
median	40.72452
Q3	40.762735
95-th percentile	40.829473
Maximum	40.91138
Range	0.41106557
Interquartile range (IQR)	0.075085

Descriptive statistics

Standard deviation	0.057559263
Coefficient of variation (CV)	0.001413237
Kurtosis	0.14019738
Mean	40.72867
Median Absolute Deviation (MAD)	0.037495659
Skewness	0.21202247
Sum	1773937.2
Variance	0.0033130687
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.76153	46	0.1%
40.76411	31	0.1%
40.7607614	22	0.1%
40.761532	22	0.1%
40.73756	19	< 0.1%
40.75436	19	< 0.1%
40.71899	18	< 0.1%
40.71579	18	< 0.1%
40.74926	17	< 0.1%
40.71933	17	< 0.1%
Other values (24576)	43326	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
40.50031443	1	< 0.1%
40.50456	1	< 0.1%
40.50848895	1	< 0.1%
40.50863	1	< 0.1%
40.51706	1	< 0.1%
40.52034	1	< 0.1%
40.52224	1	< 0.1%
40.52339	1	< 0.1%
40.52498	1	< 0.1%
40.52715449	1	< 0.1%

Value	Count	Frequency (%)
40.91138	1	< 0.1%
40.91114684	1	< 0.1%
40.9111047	1	< 0.1%
40.91074	1	< 0.1%
40.91062	1	< 0.1%
40.91037273	1	< 0.1%
40.90884	1	< 0.1%
40.906568	1	< 0.1%
40.90530196	1	< 0.1%
40.90505	1	< 0.1%

longitude
Real number (ℝ)

HIGH CORRELATION

Distinct	22105
Distinct (%)	50.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-73.943913

Minimum	-74.24984
Maximum	-73.71087
Zeros	0
Zeros (%)	0.0%
Negative	43555
Negative (%)	100.0%
Memory size	680.5 KiB

Quantile statistics

Minimum	-74.24984
5-th percentile	-74.003651
Q1	-73.98199
median	-73.95272
Q3	-73.924145
95-th percentile	-73.820704
Maximum	-73.71087
Range	0.53897
Interquartile range (IQR)	0.057845

Descriptive statistics

Standard deviation	0.056333974
Coefficient of variation (CV)	-0.00076184735
Kurtosis	3.053246
Mean	-73.943913
Median Absolute Deviation (MAD)	0.02903
Skewness	1.1441545
Sum	-3220627.1
Variance	0.0031735166
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-73.99878	46	0.1%
-73.99371	29	0.1%
-73.99391	25	0.1%
-74.00587	23	0.1%
-73.97643	23	0.1%
-73.998779	22	0.1%
-73.9861055	22	0.1%
-73.9535	20	< 0.1%
-73.99773	17	< 0.1%
-73.98532	15	< 0.1%
Other values (22095)	43313	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-74.24984	1	< 0.1%
-74.24308594	1	< 0.1%
-74.24135	1	< 0.1%
-74.23913565	1	< 0.1%
-74.21514	1	< 0.1%
-74.21126	1	< 0.1%
-74.21088	1	< 0.1%
-74.21065716	1	< 0.1%
-74.20739	1	< 0.1%
-74.20674	1	< 0.1%

Value	Count	Frequency (%)
-73.71087	1	< 0.1%
-73.71299	1	< 0.1%
-73.71383551	1	< 0.1%
-73.7154939	1	< 0.1%
-73.7174099	1	< 0.1%
-73.71974787	1	< 0.1%
-73.71991	1	< 0.1%
-73.72054	1	< 0.1%
-73.7216024	1	< 0.1%
-73.72408	1	< 0.1%

room_type
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	680.5 KiB

Entire home/apt	24645
Private room	18182
Shared room	579
Hotel room	149

Length

Max length	15
Median length	15
Mean length	13.677373
Min length	10

Characters and Unicode

Total characters	595718
Distinct characters	19
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Private room
2nd row	Entire home/apt
3rd row	Private room
4th row	Entire home/apt
5th row	Entire home/apt

Common Values

Value	Count	Frequency (%)
Entire home/apt	24645	56.6%
Private room	18182	41.7%
Shared room	579	1.3%
Hotel room	149	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
entire	24645	28.3%
home/apt	24645	28.3%
room	18910	21.7%
private	18182	20.9%
shared	579	0.7%
hotel	149	0.2%

Most occurring characters

Value	Count	Frequency (%)
e	68200	11.4%
t	67621	11.4%
o	62614	10.5%
r	62316	10.5%
m	43555	7.3%
	43555	7.3%
a	43406	7.3%
i	42827	7.2%
h	25224	4.2%
p	24645	4.1%
Other values (9)	111755	18.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	483963	81.2%
Space Separator	43555	7.3%
Uppercase Letter	43555	7.3%
Other Punctuation	24645	4.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	68200	14.1%
t	67621	14.0%
o	62614	12.9%
r	62316	12.9%
m	43555	9.0%
a	43406	9.0%
i	42827	8.8%
h	25224	5.2%
p	24645	5.1%
n	24645	5.1%
Other values (3)	18910	3.9%

Uppercase Letter

Value	Count	Frequency (%)
E	24645	56.6%
P	18182	41.7%
S	579	1.3%
H	149	0.3%

Space Separator

Value	Count	Frequency (%)
	43555	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	24645	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	527518	88.6%
Common	68200	11.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	68200	12.9%
t	67621	12.8%
o	62614	11.9%
r	62316	11.8%
m	43555	8.3%
a	43406	8.2%
i	42827	8.1%
h	25224	4.8%
p	24645	4.7%
E	24645	4.7%
Other values (7)	62465	11.8%

Common

Value	Count	Frequency (%)
	43555	63.9%
/	24645	36.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	595718	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	68200	11.4%
t	67621	11.4%
o	62614	10.5%
r	62316	10.5%
m	43555	7.3%
	43555	7.3%
a	43406	7.3%
i	42827	7.2%
h	25224	4.2%
p	24645	4.1%
Other values (9)	111755	18.8%

price
Real number (ℝ)

Distinct	1235
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	218.86385

Minimum	10
Maximum	20500
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	680.5 KiB

Quantile statistics

Minimum	10
5-th percentile	42
Q1	80
median	136
Q3	229
95-th percentile	560
Maximum	20500
Range	20490
Interquartile range (IQR)	149

Descriptive statistics

Standard deviation	442.46204
Coefficient of variation (CV)	2.0216314
Kurtosis	433.71325
Mean	218.86385
Median Absolute Deviation (MAD)	64
Skewness	16.618359
Sum	9532615
Variance	195772.65
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
150	1171	2.7%
100	1029	2.4%
200	928	2.1%
80	717	1.6%
50	714	1.6%
75	692	1.6%
120	690	1.6%
60	681	1.6%
70	658	1.5%
250	655	1.5%
Other values (1225)	35620	81.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10	6	< 0.1%
15	2	< 0.1%
16	3	< 0.1%
18	2	< 0.1%
19	4	< 0.1%
20	13	< 0.1%
21	4	< 0.1%
22	12	< 0.1%
23	14	< 0.1%
24	10	< 0.1%

Value	Count	Frequency (%)
20500	1	< 0.1%
19750	1	< 0.1%
15000	1	< 0.1%
10000	26	0.1%
9999	4	< 0.1%
9994	1	< 0.1%
9990	1	< 0.1%
9397	1	< 0.1%
9000	1	< 0.1%
8000	2	< 0.1%

min_nights
Real number (ℝ)

HIGH CORRELATION

Distinct	127
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.579474

Minimum	1
Maximum	500
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	680.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	15
Q3	30
95-th percentile	30
Maximum	500
Range	499
Interquartile range (IQR)	28

Descriptive statistics

Standard deviation	25.378979
Coefficient of variation (CV)	1.3659686
Kurtosis	92.297952
Mean	18.579474
Median Absolute Deviation (MAD)	14
Skewness	7.3440779
Sum	809229
Variance	644.09257
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30	19094	43.8%
1	7976	18.3%
2	5143	11.8%
3	3746	8.6%
5	1515	3.5%
4	1410	3.2%
7	907	2.1%
31	840	1.9%
90	476	1.1%
6	375	0.9%
Other values (117)	2073	4.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	7976	18.3%
2	5143	11.8%
3	3746	8.6%
4	1410	3.2%
5	1515	3.5%
6	375	0.9%
7	907	2.1%
8	60	0.1%
9	29	0.1%
10	224	0.5%

Value	Count	Frequency (%)
500	6	< 0.1%
480	1	< 0.1%
400	4	< 0.1%
370	1	< 0.1%
367	1	< 0.1%
366	1	< 0.1%
365	53	0.1%
364	3	< 0.1%
360	10	< 0.1%
356	1	< 0.1%

reviews_count
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	490
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	26.373367

Minimum	0
Maximum	2024
Zeros	10493
Zeros (%)	24.1%
Negative	0
Negative (%)	0.0%
Memory size	680.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	5
Q3	24
95-th percentile	131
Maximum	2024
Range	2024
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	57.746498
Coefficient of variation (CV)	2.1895763
Kurtosis	89.245198
Mean	26.373367
Median Absolute Deviation (MAD)	5
Skewness	6.1295728
Sum	1148692
Variance	3334.6581
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10493	24.1%
1	4235	9.7%
2	2719	6.2%
3	2035	4.7%
4	1602	3.7%
5	1345	3.1%
6	1155	2.7%
7	1002	2.3%
8	832	1.9%
9	786	1.8%
Other values (480)	17351	39.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10493	24.1%
1	4235	9.7%
2	2719	6.2%
3	2035	4.7%
4	1602	3.7%
5	1345	3.1%
6	1155	2.7%
7	1002	2.3%
8	832	1.9%
9	786	1.8%

Value	Count	Frequency (%)
2024	1	< 0.1%
1734	1	< 0.1%
1380	1	< 0.1%
1131	1	< 0.1%
1069	1	< 0.1%
1052	1	< 0.1%
1025	1	< 0.1%
958	1	< 0.1%
770	1	< 0.1%
763	1	< 0.1%

last_review
Text

Distinct	2859
Distinct (%)	6.6%
Missing	0
Missing (%)	0.0%
Memory size	680.5 KiB

Length

Max length	11
Median length	10
Mean length	10.240914
Min length	10

Characters and Unicode

Total characters	446043
Distinct characters	19
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	549 ?
Unique (%)	1.3%

Sample

1st row	2019-12-02
2nd row	2022-06-21
3rd row	2023-05-14
4th row	2022-08-10
5th row	2023-04-28

Value	Count	Frequency (%)
unavailable	10493	24.1%
2023-05-21	1250	2.9%
2023-05-29	1112	2.6%
2023-05-28	865	2.0%
2023-05-20	692	1.6%
2023-05-22	674	1.5%
2023-05-30	561	1.3%
2023-05-31	535	1.2%
2023-05-19	500	1.1%
2023-06-04	449	1.0%
Other values (2849)	26424	60.7%

Most occurring characters

Value	Count	Frequency (%)
2	82592	18.5%
0	77699	17.4%
-	66124	14.8%
1	31858	7.1%
a	31479	7.1%
3	26393	5.9%
l	20986	4.7%
5	15709	3.5%
n	10493	2.4%
U	10493	2.4%
Other values (9)	72217	16.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	264496	59.3%
Lowercase Letter	104930	23.5%
Dash Punctuation	66124	14.8%
Uppercase Letter	10493	2.4%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	82592	31.2%
0	77699	29.4%
1	31858	12.0%
3	26393	10.0%
5	15709	5.9%
9	7129	2.7%
6	6222	2.4%
8	6176	2.3%
4	5786	2.2%
7	4932	1.9%

Lowercase Letter

Value	Count	Frequency (%)
a	31479	30.0%
l	20986	20.0%
n	10493	10.0%
e	10493	10.0%
b	10493	10.0%
i	10493	10.0%
v	10493	10.0%

Dash Punctuation

Value	Count	Frequency (%)
-	66124	100.0%

Uppercase Letter

Value	Count	Frequency (%)
U	10493	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	330620	74.1%
Latin	115423	25.9%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	82592	25.0%
0	77699	23.5%
-	66124	20.0%
1	31858	9.6%
3	26393	8.0%
5	15709	4.8%
9	7129	2.2%
6	6222	1.9%
8	6176	1.9%
4	5786	1.8%

Latin

Value	Count	Frequency (%)
a	31479	27.3%
l	20986	18.2%
n	10493	9.1%
U	10493	9.1%
e	10493	9.1%
b	10493	9.1%
i	10493	9.1%
v	10493	9.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	446043	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	82592	18.5%
0	77699	17.4%
-	66124	14.8%
1	31858	7.1%
a	31479	7.1%
3	26393	5.9%
l	20986	4.7%
5	15709	3.5%
n	10493	2.4%
U	10493	2.4%
Other values (9)	72217	16.2%

monthly_reviews
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	880
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.92609069

Minimum	0
Maximum	63.95
Zeros	10493
Zeros (%)	24.1%
Negative	0
Negative (%)	0.0%
Memory size	680.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.01
median	0.23
Q3	1.27
95-th percentile	3.93
Maximum	63.95
Range	63.95
Interquartile range (IQR)	1.26

Descriptive statistics

Standard deviation	1.6339397
Coefficient of variation (CV)	1.7643409
Kurtosis	210.55088
Mean	0.92609069
Median Absolute Deviation (MAD)	0.23
Skewness	8.3931511
Sum	40335.88
Variance	2.669759
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10493	24.1%
0.02	1166	2.7%
0.01	1015	2.3%
0.04	790	1.8%
0.03	777	1.8%
0.05	671	1.5%
0.07	617	1.4%
1	551	1.3%
0.06	544	1.2%
0.09	515	1.2%
Other values (870)	26416	60.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10493	24.1%
0.01	1015	2.3%
0.02	1166	2.7%
0.03	777	1.8%
0.04	790	1.8%
0.05	671	1.5%
0.06	544	1.2%
0.07	617	1.4%
0.08	470	1.1%
0.09	515	1.2%

Value	Count	Frequency (%)
63.95	1	< 0.1%
61.15	1	< 0.1%
55.95	1	< 0.1%
51.48	1	< 0.1%
51.41	1	< 0.1%
41.61	1	< 0.1%
40.05	1	< 0.1%
38.84	1	< 0.1%
35.95	1	< 0.1%
32.37	1	< 0.1%

host_list_count
Real number (ℝ)

Distinct	70
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	30.941958

Minimum	1
Maximum	569
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	680.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	5
95-th percentile	219
Maximum	569
Range	568
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	99.120115
Coefficient of variation (CV)	3.2034209
Kurtosis	16.44208
Mean	30.941958
Median Absolute Deviation (MAD)	0
Skewness	4.0821216
Sum	1347677
Variance	9824.7973
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	22514	51.7%
2	5613	12.9%
3	2786	6.4%
4	1715	3.9%
5	920	2.1%
6	750	1.7%
8	584	1.3%
569	569	1.3%
7	553	1.3%
487	487	1.1%
Other values (60)	7064	16.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	22514	51.7%
2	5613	12.9%
3	2786	6.4%
4	1715	3.9%
5	920	2.1%
6	750	1.7%
7	553	1.3%
8	584	1.3%
9	378	0.9%
10	280	0.6%

Value	Count	Frequency (%)
569	569	1.3%
487	487	1.1%
412	412	0.9%
342	342	0.8%
235	235	0.5%
219	219	0.5%
207	207	0.5%
176	176	0.4%
142	142	0.3%
138	138	0.3%

availability_365
Real number (ℝ)

ZEROS

Distinct	366
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	137.00241

Minimum	0
Maximum	365
Zeros	13999
Zeros (%)	32.1%
Negative	0
Negative (%)	0.0%
Memory size	680.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	89
Q3	278
95-th percentile	362.3
Maximum	365
Range	365
Interquartile range (IQR)	278

Descriptive statistics

Standard deviation	137.34309
Coefficient of variation (CV)	1.0024866
Kurtosis	-1.4234077
Mean	137.00241
Median Absolute Deviation (MAD)	89
Skewness	0.43091324
Sum	5967140
Variance	18863.124
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	13999	32.1%
365	1267	2.9%
364	668	1.5%
339	323	0.7%
181	318	0.7%
358	249	0.6%
363	243	0.6%
155	231	0.5%
1	222	0.5%
308	220	0.5%
Other values (356)	25815	59.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	13999	32.1%
1	222	0.5%
2	166	0.4%
3	155	0.4%
4	155	0.4%
5	106	0.2%
6	78	0.2%
7	103	0.2%
8	109	0.3%
9	75	0.2%

Value	Count	Frequency (%)
365	1267	2.9%
364	668	1.5%
363	243	0.6%
362	191	0.4%
361	124	0.3%
360	164	0.4%
359	164	0.4%
358	249	0.6%
357	125	0.3%
356	111	0.3%

reviews_count_ltm
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	155
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.8839398

Minimum	0
Maximum	1128
Zeros	21644
Zeros (%)	49.7%
Negative	0
Negative (%)	0.0%
Memory size	680.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	8
95-th percentile	40
Maximum	1128
Range	1128
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	18.252904
Coefficient of variation (CV)	2.3152008
Kurtosis	633.65043
Mean	7.8839398
Median Absolute Deviation (MAD)	1
Skewness	15.116428
Sum	343385
Variance	333.16849
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	21644	49.7%
1	3234	7.4%
2	2139	4.9%
3	1674	3.8%
4	1288	3.0%
5	985	2.3%
6	812	1.9%
7	649	1.5%
8	552	1.3%
9	506	1.2%
Other values (145)	10072	23.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	21644	49.7%
1	3234	7.4%
2	2139	4.9%
3	1674	3.8%
4	1288	3.0%
5	985	2.3%
6	812	1.9%
7	649	1.5%
8	552	1.3%
9	506	1.2%

Value	Count	Frequency (%)
1128	1	< 0.1%
954	1	< 0.1%
631	1	< 0.1%
578	1	< 0.1%
553	1	< 0.1%
542	1	< 0.1%
528	1	< 0.1%
475	1	< 0.1%
457	1	< 0.1%
375	1	< 0.1%

Auto

Heatmap
Table

	id	host_id	latitude	longitude	price	min_nights	reviews_count	monthly_reviews	host_list_count	availability_365	reviews_count_ltm	nbhd_group	room_type
id	1.000	0.534	0.014	0.090	0.155	-0.345	-0.307	0.068	0.337	0.412	0.175	0.057	0.031
host_id	0.534	1.000	0.058	0.119	0.065	-0.308	-0.079	0.127	0.254	0.283	0.169	0.114	0.095
latitude	0.014	0.058	1.000	0.007	0.093	0.060	-0.095	-0.101	0.102	-0.007	-0.094	0.557	0.081
longitude	0.090	0.119	0.007	1.000	-0.401	-0.139	0.117	0.170	-0.016	0.127	0.162	0.677	0.108
price	0.155	0.065	0.093	-0.401	1.000	-0.186	-0.006	0.042	0.017	0.183	0.098	0.032	0.011
min_nights	-0.345	-0.308	0.060	-0.139	-0.186	1.000	-0.329	-0.494	-0.026	-0.230	-0.527	0.025	0.026
reviews_count	-0.307	-0.079	-0.095	0.117	-0.006	-0.329	1.000	0.866	-0.143	0.082	0.709	0.014	0.022
monthly_reviews	0.068	0.127	-0.101	0.170	0.042	-0.494	0.866	1.000	-0.067	0.220	0.858	0.028	0.033
host_list_count	0.337	0.254	0.102	-0.016	0.017	-0.026	-0.143	-0.067	1.000	0.379	0.034	0.165	0.123
availability_365	0.412	0.283	-0.007	0.127	0.183	-0.230	0.082	0.220	0.379	1.000	0.347	0.092	0.085
reviews_count_ltm	0.175	0.169	-0.094	0.162	0.098	-0.527	0.709	0.858	0.034	0.347	1.000	0.010	0.000
nbhd_group	0.057	0.114	0.557	0.677	0.032	0.025	0.014	0.028	0.165	0.092	0.010	1.000	0.093
room_type	0.031	0.095	0.081	0.108	0.011	0.026	0.022	0.033	0.123	0.085	0.000	0.093	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	id	host_id	nbhd_group	nbhd	latitude	longitude	room_type	price	min_nights	reviews_count	last_review	monthly_reviews	host_list_count	availability_365	reviews_count_ltm
0	5121	7356	Brooklyn	Bedford-Stuyvesant	40.685350	-73.955120	Private room	60	30	50	2019-12-02	0.29	2	0	0
1	2595	2845	Manhattan	Midtown	40.753560	-73.985590	Entire home/apt	240	30	49	2022-06-21	0.30	3	325	1
2	14991	59023	Manhattan	Lower East Side	40.722070	-73.989760	Private room	120	5	22	2023-05-14	0.14	1	268	3
3	5136	7378	Brooklyn	Sunset Park	40.662650	-73.994540	Entire home/apt	276	21	3	2022-08-10	0.03	1	275	1
4	59709	186084	Manhattan	Chinatown	40.717800	-73.993200	Entire home/apt	325	7	69	2023-04-28	0.47	1	38	23
5	5178	8967	Manhattan	Midtown	40.764570	-73.983170	Private room	68	2	589	2023-05-14	3.44	1	10	51
6	15341	60049	Manhattan	Lower East Side	40.721359	-73.993668	Entire home/apt	315	30	35	2023-05-23	0.30	1	160	4
7	5203	7490	Manhattan	Upper West Side	40.803800	-73.967510	Private room	75	2	118	2017-07-21	0.71	1	0	0
8	5803	9744	Brooklyn	South Slope	40.668010	-73.987840	Private room	134	3	233	2023-05-15	1.36	3	148	21
9	60164	289653	Manhattan	Tribeca	40.720120	-74.003970	Entire home/apt	500	30	110	2022-11-18	0.77	1	45	2

	id	host_id	nbhd_group	nbhd	latitude	longitude	room_type	price	min_nights	last_review	host_list_count	availability_365
43556	905010695655980384	40319757	Manhattan	Hell's Kitchen	40.766500	-73.988536	Entire home/apt	1400	3	Unavailable	14	362
43557	905013600742183325	37583303	Manhattan	Financial District	40.705111	-74.011629	Entire home/apt	350	30	Unavailable	2	180
43558	905014056309001956	40319757	Manhattan	Civic Center	40.714259	-74.005310	Entire home/apt	997	1	Unavailable	14	365
43559	905016449632638504	13384735	Brooklyn	Bushwick	40.699660	-73.922629	Private room	60	30	Unavailable	2	365
43560	905019259198729323	40319757	Manhattan	Chinatown	40.718730	-74.001030	Entire home/apt	1300	1	Unavailable	14	364
43561	905031073149861760	86368678	Brooklyn	Canarsie	40.633458	-73.899472	Entire home/apt	208	3	Unavailable	3	358
43562	905038362467988591	52064945	Brooklyn	Park Slope	40.677256	-73.981435	Private room	530	30	Unavailable	1	270
43563	905066559607295258	22541573	Manhattan	East Village	40.732530	-73.989880	Entire home/apt	382	30	Unavailable	132	288
43564	905077900484113845	151692758	Brooklyn	Canarsie	40.638210	-73.915920	Entire home/apt	199	2	Unavailable	1	155
43565	905109354552786380	25138314	Manhattan	Midtown	40.765086	-73.976717	Private room	662	1	Unavailable	116	250

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Dash Punctuation

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample